Michelle Maas
Michelle Maas
-
Re: Calculating Hours and Travel Time
Thank you, @Genevieve P. I found the error in the calculation was caused by an additional row that had been added for the 1st Jan 26, so that was adding another day to the total. Appreciate the help,…1 · -
Re: Formula calculate last 30 days referenced sheets
@NicoLHC thanks for the explanation. This morning I did a recalculation of the data sheet to compare totals and somehow now they are matching, although they weren't yesterday, which is odd - I did no…1 · -
Re: Formula calculate last 30 days referenced sheets
@Paul Newcome thanks for your help. The formula should be less than < to show the past 30 days. What is weird is when I use this version for Prospects, it calculates the correct amount: =SUM(COLLE…1 · -
Sheet Summary Formula
The above image shows the three highlighted columns I am working with in the Sheet Summary section. If I just calculate the value by subheading, it works well but I need it to identify the status: =S…1 ·
